package com.ruoyi.huanghefd.mapper;
import java.util.List;
import org.apache.ibatis.annotations.Param;

import com.ruoyi.huanghefd.domain.ApplysheetPoweroffon;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;

/**
 * @Entity com.ruoyi.huanghefd.domain.ApplysheetPoweroffon
 */
@Mapper
public interface ApplysheetPoweroffonMapper extends BaseMapper<ApplysheetPoweroffon> {

    /**
     * @Author gnplum
     * @Description //新增 停送电申请单
     * @Date 19:02 2023/11/12
     * @param applysheetPoweroffon
    * @return int
    **/
    int insertAll(ApplysheetPoweroffon applysheetPoweroffon);

    /**
     * @Author gnplum
     * @Description //删除 停送电申请单
     * @Date 19:03 2023/11/12
     * @param apCode
    * @return int
    **/
    int delByApId(@Param("apCode") String apCode);

    /**
     * @Author gnplum
     * @Description //修改 停送电申请单
     * @Date 19:04 2023/11/12
     * @param applysheetPoweroffon
    * @return int
    **/
    int updateByApId(ApplysheetPoweroffon applysheetPoweroffon);

    /**
     * @Author gnplum
     * @Description //查询 停送电申请单
     * @Date 19:07 2023/11/12
     * @param apCode
     * @param apState
     * @param userId
     * @param mailType
    * @return java.util.List<com.ruoyi.huanghefd.domain.ApplysheetPoweroffon>
    **/
    List<ApplysheetPoweroffon> queryApplysheetPoweroffonList(@Param("apCode") String apCode, @Param("apState") String apState,@Param("userId") String userId,@Param("mailType") String mailType);
    /**
     * @Author gnplum
     * @Description //查询 停送电申请单 分页
     * @Date 15:01 2024/1/3
     * @param apCode
     * @param apState
     * @param userId
     * @param mailType
     * @param startIndex
     * @param pageSize
    * @return java.util.List<com.ruoyi.huanghefd.domain.ApplysheetPoweroffon>
    **/
    List<ApplysheetPoweroffon> queryApplysheetPoweroffonListByPage(@Param("apCode") String apCode, @Param("apState") String apState,@Param("userId") String userId,@Param("mailType") String mailType,@Param("startIndex") int startIndex, @Param("pageSize") int pageSize);

    /**
     * @Author gnplum
     * @Description //获取停送电申请单编号
     * @Date 16:34 2023/11/6
     * @return int
     **/
    int getApCodeNum(@Param("PJLX") String PJLX);

    /**
     * @Author gnplum
     * @Description //停送电申请单数量
     * @Date 14:54 2024/1/3
     * @param apCode
     * @param apState
     * @param userId
     * @param mailType
    * @return int
    **/
    int getApplysheetPoweroffonNum(@Param("apCode") String apCode, @Param("apState") String apState,@Param("userId") String userId,@Param("mailType") String mailType);
}




